www.gusucode.com > 网页游戏五子棋onWeb 2008asp网站源码程序 > 网页游戏五子棋onWeb 2008asp网站源码程序/five/getRoomInfo.php
<?php include "./dbconnect.php"; $query = phpsql_query("select * from room"); $num = phpsql_num_rows($query); for($i = 0;$i < $num;$i ++) { $ID = phpsql_result($query, $i, ID); $player1_name = phpsql_result($query, $i, player1_name); $player2_name = phpsql_result($query, $i, player2_name); $player1_time = phpsql_result($query, $i, player1_time); $player2_time = phpsql_result($query, $i, player2_time); $player1_show = phpsql_result($query, $i, player1_show); $player2_show = phpsql_result($query, $i, player2_show); if($ori_time - $player1_time > 30) phpsql_query("update `room` set `flag` = '',`chess` = '',`player1_name` = '',`player1_time` = '0',`player1_win` = '0',`player1_show` = '' where `ID` = '".$ID."'"); if($ori_time - $player2_time > 30) phpsql_query("update `room` set `flag` = '',`chess` = '',`player2_name` = '',`player2_time` = '0',`player2_win` = '0',`player2_show` = '' where `ID` = '".$ID."'"); $system_time = phpsql_result($query, $i, system_time); $flag = phpsql_result($query, $i, flag); $roomInfo .= $ID."|".$player1_name."|".$player2_name."|".$flag."|".$player1_show."|".$player2_show."|;"; } echo $roomInfo; ?>